package com.ttg.model.pojo;


import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.databind.annotation.JsonDeserialize;
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
import com.ttg.common.config.LocalDateTimeDeserializer;
import com.ttg.common.config.LocalDateTimeSerializer;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

/**
 * 个人客户AUM表
 *
 * @author zhy
 * @date 2024/04/25 14:40
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName(value = "tbl_qyyx_cust_aum")
public class QyxxCustAum implements Serializable {


    private static final long serialVersionUID = -5790136628696702659L;
    /**
     * id
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    /**
     * 季度
     */
    @TableField(value = "quarter")
    private String quarter;
    /**
     * 客户姓名
     */
    @TableField(value = "cst_name")
    private String cstName;
    /**
     * 数仓客户号
     */
    @TableField(value = "cst_sc_id")
    private String cstScId;
    /**
     * 客户号
     */
    @TableField(value = "cst_id")
    private String cstId;
    /**
     * 客户的aum季日均
     */
    @TableField(value = "aum_amount_quarter_average")
    private BigDecimal aumAmountQuarterAverage;
    /**
     * 实际客户的aum季日均
     */
    @TableField(value = "aum_amount_real_quarter_average")
    private BigDecimal aumAmountRealQuarterAverage;
    /**
     * 客户的存款季日均
     */
    @TableField(value = "dep_amount_quarter_average")
    private BigDecimal depAmountQuarterAverage;
    /**
     * 实际客户的存款季日均
     */
    @TableField(value = "dep_amount_real_quarter_average")
    private BigDecimal depAmountRealQuarterAverage;
    /**
     * 客户的财富季日均
     */
    @TableField(value = "wealth_amount_quarter_average")
    private BigDecimal wealthAmountQuarterAverage;
    /**
     * 实际客户的财富季日均
     */
    @TableField(value = "wealth_amount_real_quarter_average")
    private BigDecimal wealthAmountRealQuarterAverage;
    /**
     * 客户的定期存款季日均
     */
    @TableField(value = "tm_dep_amount_quarter_average")
    private BigDecimal tmDepAmountQuarterAverage;
    /**
     * 实际客户的定期存款季日均
     */
    @TableField(value = "tm_dep_amount_real_quarter_average")
    private BigDecimal tmDepAmountRealQuarterAverage;
    /**
     * 客户的活期存款季日均
     */
    @TableField(value = "dmd_dep_amount_quarter_average")
    private BigDecimal dmdDepAmountQuarterAverage;
    /**
     * 实际客户的活期存款季日均
     */
    @TableField(value = "dmd_dep_amount_real_quarter_average")
    private BigDecimal dmdDepAmountRealQuarterAverage;
    /**
     * 季度活期存款交易总笔数（统计客户自主交易的笔数，日终交易不算）
     */
    @TableField(value = "dmd_dep_trade_quarter_count")
    private BigDecimal dmdDepTradeQuarterCount;
    /**
     * 季度活期存款交易总金额（统计客户自主交易的金额，日终交易不算）
     */
    @TableField(value = "dmd_dep_amount_quarter_total")
    private BigDecimal dmdDepAmountQuarterTotal;
    /**
     * 财富交易总笔数（统计客户自主交易的笔数，日终交易不算）
     */
    @TableField(value = "wealth_quarter_total")
    private BigDecimal wealthQuarterTotal;
    /**
     * 自营理财季日均
     */
    @TableField(value = "self_biz_fin_quarter_average")
    private BigDecimal selfBizFinQuarterAverage;
    /**
     * 实际自营理财季日均
     */
    @TableField(value = "self_biz_fin_real_quarter_average")
    private BigDecimal selfBizFinRealQuarterAverage;
    /**
     * 代销理财季日均
     */
    @TableField(value = "csn_fin_quarter_average")
    private BigDecimal csnFinQuarterAverage;
    /**
     * 实际代销理财季日均
     */
    @TableField(value = "csn_fin_real_quarter_average")
    private BigDecimal csnFinRealQuarterAverage;
    /**
     * 代销基金季日均
     */
    @TableField(value = "csn_fund_quarter_average")
    private BigDecimal csnFundQuarterAverage;
    /**
     * 实际代销基金季日均
     */
    @TableField(value = "csn_fund_real_quarter_average")
    private BigDecimal csnFundRealQuarterAverage;
    /**
     * 代销保险季日均
     */
    @TableField(value = "csn_insure_quarter_average")
    private BigDecimal csnInsureQuarterAverage;
    /**
     * 实际代销保险季日均
     */
    @TableField(value = "csn_insure_real_quarter_average")
    private BigDecimal csnInsureRealQuarterAverage;
    /**
     * 代销贵金属季日均（含积存金）
     */
    @TableField(value = "csn_metal_quarter_average")
    private BigDecimal csnMetalQuarterAverage;
    /**
     * 实际代销贵金属季日均（含积存金）
     */
    @TableField(value = "csn_metal_real_quarter_average")
    private BigDecimal csnMetalRealQuarterAverage;
    /**
     * 更新时间
     */
    @TableField(value = "update_time")
    @JsonDeserialize(using = LocalDateTimeDeserializer.class)
    @JsonSerialize(using = LocalDateTimeSerializer.class)
    private LocalDateTime updateTime;

}
